[dbo].[BAECartBillingInsert]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAECartBillingInsert
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@CartItemId
int
4
@ProductCode
varchar(256)
256
@Title
varchar(256)
256
@DuesType
varchar(256)
256
@Price
money
8
@ID
varchar(10)
10
SQL Script
create
procedure
[dbo]
.
[BAECartBillingInsert]
@CartItemId
as
int
,
@ProductCode
AS
varchar
(
256
),
@Title
AS
varchar
(
256
),
@DuesType
AS
varchar
(
256
),
@Price
AS
money
,
@ID
As
varchar
(
10
)
AS
INSERT
INTO
CartBilling
(
CartItemId
,
ProductCode
,
Title
,
DuesType
,
Price
,
ID
)
VALUES
(
@CartItemId
,
@ProductCode
,
@Title
,
@DuesType
,
@Price
,
@ID
);
SELECT
CAST
(
@@IDENTITY
AS
int
)
AS
CartBillingId
GO
Uses
[dbo].[CartBilling]
dbo